UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4bV93EZDnuw3LBIewxlg6TTXOZ6nEas1pNKrtllnnxw='
WHERE
key_id = 'ce34cfa45ed9f5e1745403c98e9c27f303e26d77f5a7e392c07e31d10cb37e5b'
AND (
token = '4bV93EZDnuw3LBIewxlg6TTXOZ6nEas1pNKrtllnnxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)