UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nj7nN8czDynww2NHsgKggKt7kA6gqimvrk2EglBPbSI='
WHERE
key_id = 'd46d9c175e0e7a85de79ee19c06e9e3e654d27a8a1fb18c6b0f63267ebf61e8a'
AND (
token = 'Nj7nN8czDynww2NHsgKggKt7kA6gqimvrk2EglBPbSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)