UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUqjC0IpNkG1hTvNMv9JPdjPj44j9hFm2hiTwWw+r6M='
WHERE
key_id = 'a185b469595c6c80d5b1fdeb072b2b11ba6563c727228fe2d76a938148dea2c1'
AND (
token = 'ZUqjC0IpNkG1hTvNMv9JPdjPj44j9hFm2hiTwWw+r6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)