UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AZiSzuWwbpKc4cRDCRhIWgoZWCPHAmdoNMVgs8jhTL4='
WHERE
key_id = 'cf991beb8c426b9f736b0872b463ad5bb18e2f117a8665314de89a731991129a'
AND (
token = 'AZiSzuWwbpKc4cRDCRhIWgoZWCPHAmdoNMVgs8jhTL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)