UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgd4mshtF/pW4Dsfl4jChJNKcmm8khpkkssenubEkcg='
WHERE
key_id = '2f1dbb67006e49e96ff6b32b7f9672a2afbfbfeb8d57fa9fb073a6d7bde54037'
AND (
token = 'zgd4mshtF/pW4Dsfl4jChJNKcmm8khpkkssenubEkcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)