UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Ot5SRmSccArKYT2is2fwxarI1XjMtz1YjlO8KQO9W4='
WHERE
key_id = '120b30906e2ec7f21ee4909eb6c19f4f7ee8dce6eb47d4d3e415af934b39f0e4'
AND (
token = '/Ot5SRmSccArKYT2is2fwxarI1XjMtz1YjlO8KQO9W4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)