UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9CdFq99eQlnJGJni3c5kTwvREMG9blXxQMnlv7RG9Xk='
WHERE
key_id = '5142fa42ca3bf89db8de337b3c17a3e6912700c21e4f3583e7fc7e4a43641b2f'
AND (
token = '9CdFq99eQlnJGJni3c5kTwvREMG9blXxQMnlv7RG9Xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)