UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HS0vpK3JmaD5kkDjNoynyB3bQLGc4ftfAZkvxOnZTyQ='
WHERE
key_id = '4c7c8405eec5360ad5306641a17154486ef1352f4d3f1516dccb5f5aad5c22c8'
AND (
token = 'HS0vpK3JmaD5kkDjNoynyB3bQLGc4ftfAZkvxOnZTyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)