UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dGa6jKtVyFafiJrC3URbRxb3XNY8BL1a+64konfUSg='
WHERE
key_id = 'a5307e17a3e1f5f796f321641113d41c31f199b6dcbb81a7bcca16e8187ff7fd'
AND (
token = '7dGa6jKtVyFafiJrC3URbRxb3XNY8BL1a+64konfUSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)