UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Q8Xn6yccOzx/SEtWL/2lV1WXYVialH7LyZNewQcn4A='
WHERE
key_id = '478d7d303b3578e0a00f5615d6b6e6ab61ee741a9730e3850f5eb5a5383d8847'
AND (
token = '5Q8Xn6yccOzx/SEtWL/2lV1WXYVialH7LyZNewQcn4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)