UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gdW+9uHJBjd0iX9MOsAzUJo+jxkJrwxUYG51AvH0XA='
WHERE
key_id = '8a9bf1231996bf2ada87044d8bfc27f161ed44ccbff6b2532fd89b895355d650'
AND (
token = '8gdW+9uHJBjd0iX9MOsAzUJo+jxkJrwxUYG51AvH0XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)