UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rJG87dEOavvgi8ZlMBDQOUji2l+6bpVwqURX+WHErWI='
WHERE
key_id = 'ad094f519d13b927cd5daf3ac36107fdde4fc94356855e360cdfe20a4dc716b4'
AND (
token = 'rJG87dEOavvgi8ZlMBDQOUji2l+6bpVwqURX+WHErWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)