UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hI8VQ1ft46/w6mBTdEJ22TfYr85vL+fsm0J4CdtR6OQ='
WHERE
key_id = 'b78d3cac906a8800f6d867e436ba4af24997ee08457a03f6611f8a1002247b49'
AND (
token = 'hI8VQ1ft46/w6mBTdEJ22TfYr85vL+fsm0J4CdtR6OQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)