UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HRPD6yH8+bC6pehIo+0ZSEo4Dmsg6tZK7+1uroVKS4='
WHERE
key_id = '6bb0d5f8e5d92acf7496f3696c34c912eed1ff4b4bed8a0d5cd19f01254788a7'
AND (
token = '7HRPD6yH8+bC6pehIo+0ZSEo4Dmsg6tZK7+1uroVKS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)