UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WuY36t49E0XQIrvQLR5mM+JX36WGrDet4n9qOE9na8Q='
WHERE
key_id = 'd0a8bc093b6063fecd04027f4b4d7e9ce6bcf12c91f73140ef34b4b8452b9970'
AND (
token = 'WuY36t49E0XQIrvQLR5mM+JX36WGrDet4n9qOE9na8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)