UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4nQ6yfzP3kZAkuw9jyJM5MLptaYMe3Uyn9WJ0RBjCcA='
WHERE
key_id = 'a2c066534ee0102ca4161e0472cf1bda841b6a2dded05ea47d2796b1c688d5e7'
AND (
token = '4nQ6yfzP3kZAkuw9jyJM5MLptaYMe3Uyn9WJ0RBjCcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)