UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vJIBJJ4iF33E9X1fgzlzX67PIKp9OkIHB0Ks4IWqMqk='
WHERE
key_id = '8671a5956a444b8e5f2dc242987c0dc4aba5f9f17785444d6e8b54742b42558a'
AND (
token = 'vJIBJJ4iF33E9X1fgzlzX67PIKp9OkIHB0Ks4IWqMqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)