UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uRBbJiovhtGgK6RMtZkZJVcqJ5y4yf8Qh3dU5N3k4ME='
WHERE
key_id = 'a6166390b16a481a9087d776e152ec0257b6114355317224c4c528cf7cd50b1e'
AND (
token = 'uRBbJiovhtGgK6RMtZkZJVcqJ5y4yf8Qh3dU5N3k4ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)