UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pGQPaNQx/6PKxJ6cXi1lQ1dGqirxrQacmeehdF2i44='
WHERE
key_id = '0812a80e96d0748507df471c78590755820495327ca3c5ed6bce0508f588d3a4'
AND (
token = '1pGQPaNQx/6PKxJ6cXi1lQ1dGqirxrQacmeehdF2i44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)