UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WV6sPeXkx6NYlHqYiapL2KBxnfcXR+flraVc8nWU+s4='
WHERE
key_id = '99146d6f4a82f3d1a1be805932624c8a38c12eb7785699b234fe5a5fa3db114c'
AND (
token = 'WV6sPeXkx6NYlHqYiapL2KBxnfcXR+flraVc8nWU+s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)