UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TYs1wrEgIbgLNDRWv8qnrBXS5xvNhex6tchSiF2iTxw='
WHERE
key_id = 'c5973d3aa91fb1c7ed41ed9fe38e3d6566938470089a7457e6eab1a2651b80b8'
AND (
token = 'TYs1wrEgIbgLNDRWv8qnrBXS5xvNhex6tchSiF2iTxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)