UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzkmBgaU65ieClB1xMRVPGu0ldxbig5EJU7i284ofAc='
WHERE
key_id = '94ba7e5b73df1e5af904b048738ea28fdd17e1ae671a002d49db6c4620b88570'
AND (
token = 'mzkmBgaU65ieClB1xMRVPGu0ldxbig5EJU7i284ofAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)