UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hK6aY/phkMdQAZnJ8kSm8uv7AfwH5K9s+xx+MyiAxqc='
WHERE
key_id = '1a8978b2d205d512fb79787b1bd6b762cd216b6ace2a34a2f27cf75e64ad9267'
AND (
token = 'hK6aY/phkMdQAZnJ8kSm8uv7AfwH5K9s+xx+MyiAxqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)