UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXwy2pIMx7LnduFo8ZhbxKtzYk6kFnbpxB++tk4sAyk='
WHERE
key_id = 'a2871b72a9a764b6b3a07a9c65814e245e159e5a74acf1f34ff46aa13c6aac98'
AND (
token = 'sXwy2pIMx7LnduFo8ZhbxKtzYk6kFnbpxB++tk4sAyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)