UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGfB/YMKlOEa6D3dW8eXVt3vivThdU+D6CZGr78d1Cw='
WHERE
key_id = '09786987c3f547f2790986578ae78550dfe169bd4da6c567e1bdd90c97888023'
AND (
token = 'BGfB/YMKlOEa6D3dW8eXVt3vivThdU+D6CZGr78d1Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)