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