UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1jkkIySCY6UBD8aXOJ11ro9gQ4XO4GDd7AXlXIVeew='
WHERE
key_id = '662ca7f95342f65e02b35a317cafe31124625097b1374998d9a5a45d292def80'
AND (
token = 'W1jkkIySCY6UBD8aXOJ11ro9gQ4XO4GDd7AXlXIVeew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)