UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxJtqy8cpkSog7RKvWlte6aKkJ7/yPx5Lw1WL+OwDgA='
WHERE
key_id = '6b18e0bda7ad7395de501cab08d577fc94423b44805817965d90f979f603bb11'
AND (
token = 'mxJtqy8cpkSog7RKvWlte6aKkJ7/yPx5Lw1WL+OwDgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)