UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59A4dNKAvYdWt3WnazlKs8LYC0xfX84/owKC1XSNx+o='
WHERE
key_id = '29bc6509483d3e27225ae203cdd509e28b2565f257b0acb40d708125abfead01'
AND (
token = '59A4dNKAvYdWt3WnazlKs8LYC0xfX84/owKC1XSNx+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)