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