UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lfg0htVH86ENMH11i8AAjO/v4qCUM//5zSOvmCZrmAo='
WHERE
key_id = '1861e03c74cc1c1901b5f3738e52cdb88e5189712942b6393091a3e8a2beb488'
AND (
token = 'Lfg0htVH86ENMH11i8AAjO/v4qCUM//5zSOvmCZrmAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)