UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jNW0bBe+1DPDnkG+3UpMsxzhFPxsqNSv0wLoj9etP4o='
WHERE
key_id = '007c10bbe6b3dee387765da63c8ea90edb67af448bb015779c0f4fed93ccb830'
AND (
token = 'jNW0bBe+1DPDnkG+3UpMsxzhFPxsqNSv0wLoj9etP4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)