UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MTxaofZfo9/gD7LjRLWosA0rN0FhNwnsve4K9j8l0U='
WHERE
key_id = '766ea16a726f789c0acb209fb9faa870a28700ad6e9fa1475c02896cb8986cbf'
AND (
token = '0MTxaofZfo9/gD7LjRLWosA0rN0FhNwnsve4K9j8l0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)