UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6SXDCuolk1NpoLZ1o7PfS0cPUFNjb3EpniU2nvmyjw='
WHERE
key_id = '729c03e92f622bdb08ff279f3c0a0aa6826ce23c40f95fc9559f1ef5f4db7a96'
AND (
token = 'k6SXDCuolk1NpoLZ1o7PfS0cPUFNjb3EpniU2nvmyjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)