UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mgzOAiMv9bSApJGcaY6R+hbz005j6hJBwND/28f8bI='
WHERE
key_id = '789da89d28795d7bc5aa7fd2aa38ce555efafee08389125d5fd2c696bce22c0e'
AND (
token = '8mgzOAiMv9bSApJGcaY6R+hbz005j6hJBwND/28f8bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)