UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXSB0fwDCkhhtdnPpuqfuw5BDRzZ1cpBb7G38woDF7M='
WHERE
key_id = '535a422448d4a70d55c48a60efa55c595b95283c4f24b10513cc8a9a37a8b071'
AND (
token = 'zXSB0fwDCkhhtdnPpuqfuw5BDRzZ1cpBb7G38woDF7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)