UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQpycdhN0TXfIFOTDCAjWdsObcKs+T9+l/q+1gxzPA0='
WHERE
key_id = '7fb5392e6f4e5c09373e77f9733add952543c09db6951b18db1eba6ecc5b8967'
AND (
token = 'gQpycdhN0TXfIFOTDCAjWdsObcKs+T9+l/q+1gxzPA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)