UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBTDRzCNChGgjh4jPjZILMe8Si/9i2UlICLIyjYmVek='
WHERE
key_id = '50e83628c15ec1f9b994a6398ba14d42290b69b6b433a2fb407020501674fba0'
AND (
token = 'ZBTDRzCNChGgjh4jPjZILMe8Si/9i2UlICLIyjYmVek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)