UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LAE92ak5OQWDhpyT+HPiUoMDvdU8l5GqG2nr3DBPRo='
WHERE
key_id = 'c2a6c27dc88302f66f67ee6f52dc52b171755adac2a89592c39e4855debcf2ea'
AND (
token = '0LAE92ak5OQWDhpyT+HPiUoMDvdU8l5GqG2nr3DBPRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)