UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPELCs5vPvuWuZC/BGYm8HbkHDJbeTx/JSdXlRUr0Ms='
WHERE
key_id = '505d0c6871309e9c2a07a452cff95366fb6fdaff68a6829fd2bdc3f9d33344f9'
AND (
token = 'KPELCs5vPvuWuZC/BGYm8HbkHDJbeTx/JSdXlRUr0Ms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)