UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifhbSXCNNV6edOZxs7LAZx5PbH6X1WlJHvlfC0Z0DiE='
WHERE
key_id = '7a29f9ddfe8a3482fccefdf03f08a7dcb9b8da2bb4070d9ee186ddd311c202d8'
AND (
token = 'ifhbSXCNNV6edOZxs7LAZx5PbH6X1WlJHvlfC0Z0DiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)