UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLFD0M+b42V0ubjy0eKRkuX9H3PlqA68aYWhUNp9Gw4='
WHERE
key_id = 'f8776bef093576e19ae33c6d3fbe025c0314fe4e36825ae43c640047d6f42916'
AND (
token = 'cLFD0M+b42V0ubjy0eKRkuX9H3PlqA68aYWhUNp9Gw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)